Pandas Profiling Report

Dataset statistics

Number of variables	19
Number of observations	99958
Missing cells	0
Missing cells (%)	0.0%
Duplicate rows	0
Duplicate rows (%)	0.0%
Total size in memory	14.5 MiB
Average record size in memory	152.0 B

Variable types

Numeric	13
Categorical	6

Warnings

`df_index` is highly correlated with `primary_key`	High correlation
`primary_key` is highly correlated with `df_index`	High correlation
`voice_oob_mean` is highly correlated with `voice_oob_sum`	High correlation
`voice_oob_sum` is highly correlated with `voice_oob_mean`	High correlation
`voice_oob_nat_mean` is highly correlated with `voice_oob_nat_sum`	High correlation
`voice_oob_nat_sum` is highly correlated with `voice_oob_nat_mean`	High correlation
`primary_key` is uniformly distributed	Uniform
`df_index` has unique values	Unique
`primary_key` has unique values	Unique
`r_age_val` has unique values	Unique
`count_orange` has 83374 (83.4%) zeros	Zeros
`voice_oob_mean` has 65925 (66.0%) zeros	Zeros
`voice_oob_sum` has 65925 (66.0%) zeros	Zeros
`voice_oob_nat_mean` has 80337 (80.4%) zeros	Zeros
`voice_oob_nat_sum` has 80337 (80.4%) zeros	Zeros

Reproduction

Analysis started	2021-01-16 21:41:37.003491
Analysis finished	2021-01-16 21:42:25.890091
Duration	48.89 seconds
Software version	pandas-profiling v2.10.0
Download configuration	config.yaml

df_index
Real number (ℝ_≥0)

HIGH CORRELATION
UNIQUE

Distinct	99958
Distinct (%)	100.0%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%

Mean	50580.26431
Minimum	0
Maximum	100999
Zeros	1
Zeros (%)	< 0.1%
Memory size	781.0 KiB

Quantile statistics

Minimum	0
5-th percentile	4998.85
Q1	24993.25
median	50993.5
Q3	75997.75
95-th percentile	96000.15
Maximum	100999
Range	100999
Interquartile range (IQR)	51004.5

Descriptive statistics

Standard deviation	29291.26667
Coefficient of variation (CV)	0.5791046581
Kurtosis	-1.215053109
Mean	50580.26431
Median Absolute Deviation (MAD)	25502.5
Skewness	-0.008149656078
Sum	5055902060
Variance	857978303.2
Monotocity	Strictly increasing

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
2047	1	< 0.1%
84668	1	< 0.1%
4759	1	< 0.1%
27288	1	< 0.1%
25241	1	< 0.1%
31386	1	< 0.1%
29339	1	< 0.1%
19100	1	< 0.1%
17053	1	< 0.1%
23198	1	< 0.1%
Other values (99948)	99948	> 99.9%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
0	1	< 0.1%
1	1	< 0.1%
2	1	< 0.1%
3	1	< 0.1%
4	1	< 0.1%

Value	Count	Frequency (%)
100999	1	< 0.1%
100998	1	< 0.1%
100997	1	< 0.1%
100996	1	< 0.1%
100995	1	< 0.1%

primary_key
Real number (ℝ_≥0)

HIGH CORRELATION
UNIFORM
UNIQUE

Distinct	99958
Distinct (%)	100.0%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%

Mean	49997.85928
Minimum	1
Maximum	100000
Zeros	0
Zeros (%)	0.0%
Memory size	781.0 KiB

Quantile statistics

Minimum	1
5-th percentile	4999.85
Q1	24994.25
median	49994.5
Q3	74998.75
95-th percentile	95001.15
Maximum	100000
Range	99999
Interquartile range (IQR)	50004.5

Descriptive statistics

Standard deviation	28869.17893
Coefficient of variation (CV)	0.5774083
Kurtosis	-1.200138451
Mean	49997.85928
Median Absolute Deviation (MAD)	25002.5
Skewness	0.0001647137656
Sum	4997686018
Variance	833429492.1
Monotocity	Strictly increasing

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
2047	1	< 0.1%
39622	1	< 0.1%
76464	1	< 0.1%
74417	1	< 0.1%
80562	1	< 0.1%
78515	1	< 0.1%
68276	1	< 0.1%
66229	1	< 0.1%
72374	1	< 0.1%
70327	1	< 0.1%
Other values (99948)	99948	> 99.9%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
1	1	< 0.1%
2	1	< 0.1%
3	1	< 0.1%
4	1	< 0.1%
5	1	< 0.1%

Value	Count	Frequency (%)
100000	1	< 0.1%
99999	1	< 0.1%
99998	1	< 0.1%
99997	1	< 0.1%
99996	1	< 0.1%

r_age_val
Real number (ℝ_≥0)

UNIQUE

Distinct	99958
Distinct (%)	100.0%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%

Mean	0.498642977
Minimum	3.23667191 × 10⁵
Maximum	0.9999880234
Zeros	0
Zeros (%)	0.0%
Memory size	781.0 KiB

Quantile statistics

Minimum	3.23667191 × 10⁵
5-th percentile	0.04917355964
Q1	0.2493645223
median	0.497055489
Q3	0.7497351963
95-th percentile	0.9499201727
Maximum	0.9999880234
Range	0.9999556567
Interquartile range (IQR)	0.500370674

Descriptive statistics

Standard deviation	0.2889375317
Coefficient of variation (CV)	0.5794477113
Kurtosis	-1.200737397
Mean	0.498642977
Median Absolute Deviation (MAD)	0.2501880743
Skewness	0.006012226328
Sum	49843.35469
Variance	0.08348489725
Monotocity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0.1840802424	1	< 0.1%
0.7935401013	1	< 0.1%
0.458713362	1	< 0.1%
0.8191695667	1	< 0.1%
0.1122393482	1	< 0.1%
0.7174767267	1	< 0.1%
0.1196117112	1	< 0.1%
0.5353033876	1	< 0.1%
0.1366209837	1	< 0.1%
0.2337465684	1	< 0.1%
Other values (99948)	99948	> 99.9%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
3.23667191 × 10⁵	1	< 0.1%
4.471326247 × 10⁵	1	< 0.1%
5.069980398 × 10⁵	1	< 0.1%
8.817738853 × 10⁵	1	< 0.1%
9.196507744 × 10⁵	1	< 0.1%

Value	Count	Frequency (%)
0.9999880234	1	< 0.1%
0.9999297063	1	< 0.1%
0.9998888529	1	< 0.1%
0.9998853074	1	< 0.1%
0.9998679473	1	< 0.1%

cust_gender_cd
Categorical

Distinct	3
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	781.0 KiB

F	50154
M	45738
Unknown	4066

Length

Max length	7
Median length	1
Mean length	1.244062506
Min length	1

Characters and Unicode

Total characters	124354
Distinct characters	7
Distinct categories	2 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	F
2nd row	M
3rd row	F
4th row	M
5th row	F

Value	Count	Frequency (%)
F	50154	50.2%
M	45738	45.8%
Unknown	4066	4.1%

Histogram of lengths of the category

Value	Count	Frequency (%)
f	50154	50.2%
m	45738	45.8%
unknown	4066	4.1%

Most occurring characters

Value	Count	Frequency (%)
F	50154	40.3%
M	45738	36.8%
n	12198	9.8%
U	4066	3.3%
k	4066	3.3%
o	4066	3.3%
w	4066	3.3%

Most occurring categories

Value	Count	Frequency (%)
Uppercase Letter	99958	80.4%
Lowercase Letter	24396	19.6%

Most frequent character per category

Value	Count	Frequency (%)
n	12198	50.0%
k	4066	16.7%
o	4066	16.7%
w	4066	16.7%

Value	Count	Frequency (%)
F	50154	50.2%
M	45738	45.8%
U	4066	4.1%

Most occurring scripts

Value	Count	Frequency (%)
Latin	124354	100.0%

Most frequent character per script

Value	Count	Frequency (%)
F	50154	40.3%
M	45738	36.8%
n	12198	9.8%
U	4066	3.3%
k	4066	3.3%
o	4066	3.3%
w	4066	3.3%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	124354	100.0%

Most frequent character per block

Value	Count	Frequency (%)
F	50154	40.3%
M	45738	36.8%
n	12198	9.8%
U	4066	3.3%
k	4066	3.3%
o	4066	3.3%
w	4066	3.3%

cust_language_cd
Categorical

Distinct	4
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	781.0 KiB

FR	53841
NL	45606
EN	374
DE	137

Length

Max length	2
Median length	2
Mean length	2
Min length	2

Characters and Unicode

Total characters	199916
Distinct characters	6
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	FR
2nd row	FR
3rd row	FR
4th row	FR
5th row	NL

Value	Count	Frequency (%)
FR	53841	53.9%
NL	45606	45.6%
EN	374	0.4%
DE	137	0.1%

Histogram of lengths of the category

Value	Count	Frequency (%)
fr	53841	53.9%
nl	45606	45.6%
en	374	0.4%
de	137	0.1%

Most occurring characters

Value	Count	Frequency (%)
F	53841	26.9%
R	53841	26.9%
N	45980	23.0%
L	45606	22.8%
E	511	0.3%
D	137	0.1%

Most occurring categories

Value	Count	Frequency (%)
Uppercase Letter	199916	100.0%

Most frequent character per category

Value	Count	Frequency (%)
F	53841	26.9%
R	53841	26.9%
N	45980	23.0%
L	45606	22.8%
E	511	0.3%
D	137	0.1%

Most occurring scripts

Value	Count	Frequency (%)
Latin	199916	100.0%

Most frequent character per script

Value	Count	Frequency (%)
F	53841	26.9%
R	53841	26.9%
N	45980	23.0%
L	45606	22.8%
E	511	0.3%
D	137	0.1%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	199916	100.0%

Most frequent character per block

Value	Count	Frequency (%)
F	53841	26.9%
R	53841	26.9%
N	45980	23.0%
L	45606	22.8%
E	511	0.3%
D	137	0.1%

cust_mkt_segm_desc
Categorical

Distinct	2
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	781.0 KiB

MASS	92900
SOHO	7058

Length

Max length	4
Median length	4
Mean length	4
Min length	4

Characters and Unicode

Total characters	399832
Distinct characters	5
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	MASS
2nd row	MASS
3rd row	MASS
4th row	MASS
5th row	MASS

Value	Count	Frequency (%)
MASS	92900	92.9%
SOHO	7058	7.1%

Histogram of lengths of the category

Value	Count	Frequency (%)
mass	92900	92.9%
soho	7058	7.1%

Most occurring characters

Value	Count	Frequency (%)
S	192858	48.2%
M	92900	23.2%
A	92900	23.2%
O	14116	3.5%
H	7058	1.8%

Most occurring categories

Value	Count	Frequency (%)
Uppercase Letter	399832	100.0%

Most frequent character per category

Value	Count	Frequency (%)
S	192858	48.2%
M	92900	23.2%
A	92900	23.2%
O	14116	3.5%
H	7058	1.8%

Most occurring scripts

Value	Count	Frequency (%)
Latin	399832	100.0%

Most frequent character per script

Value	Count	Frequency (%)
S	192858	48.2%
M	92900	23.2%
A	92900	23.2%
O	14116	3.5%
H	7058	1.8%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	399832	100.0%

Most frequent character per block

Value	Count	Frequency (%)
S	192858	48.2%
M	92900	23.2%
A	92900	23.2%
O	14116	3.5%
H	7058	1.8%

trf_mdl_phonedeal_cd
Categorical

Distinct	2
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	781.0 KiB

0	62964
1	36994

Length

Max length	1
Median length	1
Mean length	1
Min length	1

Characters and Unicode

Total characters	99958
Distinct characters	2
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	0
2nd row	0
3rd row	0
4th row	1
5th row	0

Value	Count	Frequency (%)
0	62964	63.0%
1	36994	37.0%

Histogram of lengths of the category

Value	Count	Frequency (%)
0	62964	63.0%
1	36994	37.0%

Most occurring characters

Value	Count	Frequency (%)
0	62964	63.0%
1	36994	37.0%

Most occurring categories

Value	Count	Frequency (%)
Decimal Number	99958	100.0%

Most frequent character per category

Value	Count	Frequency (%)
0	62964	63.0%
1	36994	37.0%

Most occurring scripts

Value	Count	Frequency (%)
Common	99958	100.0%

Most frequent character per script

Value	Count	Frequency (%)
0	62964	63.0%
1	36994	37.0%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	99958	100.0%

Most frequent character per block

Value	Count	Frequency (%)
0	62964	63.0%
1	36994	37.0%

count_orange
Real number (ℝ_≥0)

ZEROS

Distinct	7
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%

Mean	0.1896796655
Minimum	0
Maximum	6
Zeros	83374
Zeros (%)	83.4%
Memory size	781.0 KiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0
median	0
Q3	0
95-th percentile	1
Maximum	6
Range	6
Interquartile range (IQR)	0

Descriptive statistics

Standard deviation	0.4549128731
Coefficient of variation (CV)	2.398321781
Kurtosis	7.808397147
Mean	0.1896796655
Median Absolute Deviation (MAD)	0
Skewness	2.598609855
Sum	18960
Variance	0.2069457221
Monotocity	Not monotonic

Histogram with fixed size bins (bins=7)

Value	Count	Frequency (%)
0	83374	83.4%
1	14457	14.5%
2	1906	1.9%
3	200	0.2%
4	15	< 0.1%
5	5	< 0.1%
6	1	< 0.1%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
0	83374	83.4%
1	14457	14.5%
2	1906	1.9%
3	200	0.2%
4	15	< 0.1%

Value	Count	Frequency (%)
6	1	< 0.1%
5	5	< 0.1%
4	15	< 0.1%
3	200	0.2%
2	1906	1.9%

cust_total_mobile_qty
Categorical

Distinct	5
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	781.0 KiB

1	63875
2	22980
3	9035
4	4067
6	1

Length

Max length	1
Median length	1
Mean length	1
Min length	1

Characters and Unicode

Total characters	99958
Distinct characters	5
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	1 ?
Unique (%)	< 0.1%

Sample

1st row	1
2nd row	1
3rd row	1
4th row	2
5th row	1

Value	Count	Frequency (%)
1	63875	63.9%
2	22980	23.0%
3	9035	9.0%
4	4067	4.1%
6	1	< 0.1%

Histogram of lengths of the category

Value	Count	Frequency (%)
1	63875	63.9%
2	22980	23.0%
3	9035	9.0%
4	4067	4.1%
6	1	< 0.1%

Most occurring characters

Value	Count	Frequency (%)
1	63875	63.9%
2	22980	23.0%
3	9035	9.0%
4	4067	4.1%
6	1	< 0.1%

Most occurring categories

Value	Count	Frequency (%)
Decimal Number	99958	100.0%

Most frequent character per category

Value	Count	Frequency (%)
1	63875	63.9%
2	22980	23.0%
3	9035	9.0%
4	4067	4.1%
6	1	< 0.1%

Most occurring scripts

Value	Count	Frequency (%)
Common	99958	100.0%

Most frequent character per script

Value	Count	Frequency (%)
1	63875	63.9%
2	22980	23.0%
3	9035	9.0%
4	4067	4.1%
6	1	< 0.1%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	99958	100.0%

Most frequent character per block

Value	Count	Frequency (%)
1	63875	63.9%
2	22980	23.0%
3	9035	9.0%
4	4067	4.1%
6	1	< 0.1%

voice_oob_mean
Real number (ℝ_≥0)

HIGH CORRELATION
ZEROS

Distinct	23763
Distinct (%)	23.8%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%

Mean	1.764173275
Minimum	0
Maximum	375.3951333
Zeros	65925
Zeros (%)	66.0%
Memory size	781.0 KiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0
median	0
Q3	0.775958335
95-th percentile	9.468136669
Maximum	375.3951333
Range	375.3951333
Interquartile range (IQR)	0.775958335

Descriptive statistics

Standard deviation	6.325627466
Coefficient of variation (CV)	3.585604406
Kurtosis	442.1400149
Mean	1.764173275
Median Absolute Deviation (MAD)	0
Skewness	14.10221597
Sum	176343.2322
Variance	40.01356284
Monotocity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	65925	66.0%
0.2755	1395	1.4%
0.17906667	767	0.8%
0.551	433	0.4%
0.55096667	274	0.3%
0.8265	205	0.2%
0.41323333	199	0.2%
0.35813333	167	0.2%
1.102	85	0.1%
0.45456667	80	0.1%
Other values (23753)	30428	30.4%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
0	65925	66.0%
0.00093333	1	< 0.1%
0.00113333	4	< 0.1%
0.00183333	1	< 0.1%
0.0023	5	< 0.1%

Value	Count	Frequency (%)
375.3951333	1	< 0.1%
353.3198667	1	< 0.1%
275.4740667	1	< 0.1%
243.3725333	1	< 0.1%
237.3467	1	< 0.1%

voice_oob_sum
Real number (ℝ_≥0)

HIGH CORRELATION
ZEROS

Distinct	23674
Distinct (%)	23.7%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%

Mean	5.265834626
Minimum	0
Maximum	1126.1854
Zeros	65925
Zeros (%)	66.0%
Memory size	781.0 KiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0
median	0
Q3	2.29465
95-th percentile	28.35906
Maximum	1126.1854
Range	1126.1854
Interquartile range (IQR)	2.29465

Descriptive statistics

Standard deviation	18.83123087
Coefficient of variation (CV)	3.576115129
Kurtosis	439.4605764
Mean	5.265834626
Median Absolute Deviation (MAD)	0
Skewness	13.99401962
Sum	526362.2975
Variance	354.6152561
Monotocity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	65925	66.0%
0.8265	1429	1.4%
0.5372	779	0.8%
1.653	450	0.5%
1.6529	281	0.3%
1.2397	202	0.2%
2.4795	190	0.2%
1.0744	170	0.2%
3.306	87	0.1%
1.3637	80	0.1%
Other values (23664)	30365	30.4%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
0	65925	66.0%
0.0028	1	< 0.1%
0.0034	4	< 0.1%
0.0055	1	< 0.1%
0.0069	5	< 0.1%

Value	Count	Frequency (%)
1126.1854	1	< 0.1%
1059.9596	1	< 0.1%
826.4222	1	< 0.1%
730.1176	1	< 0.1%
712.0196	1	< 0.1%

voice_oob_nat_mean
Real number (ℝ_≥0)

HIGH CORRELATION
ZEROS

Distinct	17160
Distinct (%)	17.2%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%

Mean	1.087095392
Minimum	0
Maximum	275.4740667
Zeros	80337
Zeros (%)	80.4%
Memory size	781.0 KiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0
median	0
Q3	0
95-th percentile	6.494221669
Maximum	275.4740667
Range	275.4740667
Interquartile range (IQR)	0

Descriptive statistics

Standard deviation	4.475306891
Coefficient of variation (CV)	4.116756382
Kurtosis	377.5297469
Mean	1.087095392
Median Absolute Deviation (MAD)	0
Skewness	12.70083205
Sum	108663.8811
Variance	20.02837177
Monotocity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	80337	80.4%
0.06886667	13	< 0.1%
0.0551	11	< 0.1%
0.04476667	10	< 0.1%
0.1056	9	< 0.1%
0.12856667	9	< 0.1%
0.12396667	8	< 0.1%
0.17446667	8	< 0.1%
0.13773333	8	< 0.1%
0.07576667	8	< 0.1%
Other values (17150)	19537	19.5%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
0	80337	80.4%
0.00093333	1	< 0.1%
0.00113333	4	< 0.1%
0.00183333	1	< 0.1%
0.0023	6	< 0.1%

Value	Count	Frequency (%)
275.4740667	1	< 0.1%
243.3725333	1	< 0.1%
169.75	1	< 0.1%
163.5384	1	< 0.1%
136.4082667	1	< 0.1%

voice_oob_nat_sum
Real number (ℝ_≥0)

HIGH CORRELATION
ZEROS

Distinct	17138
Distinct (%)	17.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%

Mean	3.254846711
Minimum	0
Maximum	826.4222
Zeros	80337
Zeros (%)	80.4%
Memory size	781.0 KiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0
median	0
Q3	0
95-th percentile	19.43995
Maximum	826.4222
Range	826.4222
Interquartile range (IQR)	0

Descriptive statistics

Standard deviation	13.39464728
Coefficient of variation (CV)	4.115292814
Kurtosis	380.0509556
Mean	3.254846711
Median Absolute Deviation (MAD)	0
Skewness	12.72397772
Sum	325347.9675
Variance	179.4165757
Monotocity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	80337	80.4%
0.2066	13	< 0.1%
0.1653	11	< 0.1%
0.1343	10	< 0.1%
0.3857	9	< 0.1%
0.3168	9	< 0.1%
0.4132	8	< 0.1%
0.4408	8	< 0.1%
0.2273	8	< 0.1%
0.3719	8	< 0.1%
Other values (17128)	19537	19.5%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
0	80337	80.4%
0.0028	1	< 0.1%
0.0034	4	< 0.1%
0.0055	1	< 0.1%
0.0069	6	< 0.1%

Value	Count	Frequency (%)
826.4222	1	< 0.1%
730.1176	1	< 0.1%
509.25	1	< 0.1%
490.6152	1	< 0.1%
409.2248	1	< 0.1%

mean_bill_rev_vs_trf_plan
Real number (ℝ_≥0)

Distinct	70560
Distinct (%)	70.6%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%

Mean	1.102395808
Minimum	0
Maximum	39.50738889
Zeros	349
Zeros (%)	0.3%
Memory size	781.0 KiB

Quantile statistics

Minimum	0
5-th percentile	0.7438
Q1	0.8319972225
median	0.910143611
Q3	1.150698167
95-th percentile	2.015644283
Maximum	39.50738889
Range	39.50738889
Interquartile range (IQR)	0.3187009444

Descriptive statistics

Standard deviation	0.6514355205
Coefficient of variation (CV)	0.5909270658
Kurtosis	319.3943029
Mean	1.102395808
Median Absolute Deviation (MAD)	0.083698611
Skewness	10.76682523
Sum	110193.2802
Variance	0.4243682374
Monotocity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0.8264466667	3531	3.5%
0.8264416667	2409	2.4%
0.82645	2295	2.3%
0.826445	1592	1.6%
0.99174	984	1.0%
0.826444	838	0.8%
0.72727	456	0.5%
0.8308911113	377	0.4%
0.8264457143	366	0.4%
0	349	0.3%
Other values (70550)	86761	86.8%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
0	349	0.3%
0.0002527775	1	< 0.1%
0.002475	1	< 0.1%
0.002533333333	1	< 0.1%
0.005555555833	1	< 0.1%

Value	Count	Frequency (%)
39.50738889	1	< 0.1%
33.10309778	1	< 0.1%
29.73575333	1	< 0.1%
27.03434533	1	< 0.1%
19.176725	1	< 0.1%

tenure_days
Real number (ℝ_≥0)

Distinct	7085
Distinct (%)	7.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%

Mean	2619.986714
Minimum	88
Maximum	7461
Zeros	0
Zeros (%)	0.0%
Memory size	781.0 KiB

Quantile statistics

Minimum	88
5-th percentile	207
Q1	772
median	2054
Q3	4412
95-th percentile	6233.15
Maximum	7461
Range	7373
Interquartile range (IQR)	3640

Descriptive statistics

Standard deviation	2050.001721
Coefficient of variation (CV)	0.7824473725
Kurtosis	-1.073057737
Mean	2619.986714
Median Absolute Deviation (MAD)	1535
Skewness	0.5220895246
Sum	261888632
Variance	4202507.055
Monotocity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
202	147	0.1%
422	145	0.1%
406	135	0.1%
415	112	0.1%
181	102	0.1%
401	95	0.1%
411	94	0.1%
408	94	0.1%
107	93	0.1%
410	92	0.1%
Other values (7075)	98849	98.9%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
88	6	< 0.1%
90	3	< 0.1%
91	8	< 0.1%
93	3	< 0.1%
95	8	< 0.1%

Value	Count	Frequency (%)
7461	1	< 0.1%
7460	1	< 0.1%
7459	1	< 0.1%
7456	1	< 0.1%
7455	1	< 0.1%

days_since_moving
Real number (ℝ_≥0)

Distinct	358
Distinct (%)	0.4%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%

Mean	358.6777246
Minimum	4
Maximum	365
Zeros	0
Zeros (%)	0.0%
Memory size	781.0 KiB

Quantile statistics

Minimum	4
5-th percentile	365
Q1	365
median	365
Q3	365
95-th percentile	365
Maximum	365
Range	361
Interquartile range (IQR)	0

Descriptive statistics

Standard deviation	37.25369475
Coefficient of variation (CV)	0.1038639765
Kurtosis	45.43473743
Mean	358.6777246
Median Absolute Deviation (MAD)	0
Skewness	-6.604567379
Sum	35852708
Variance	1387.837772
Monotocity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
365	96180	96.2%
294	44	< 0.1%
181	26	< 0.1%
237	24	< 0.1%
301	24	< 0.1%
286	24	< 0.1%
321	23	< 0.1%
209	23	< 0.1%
207	22	< 0.1%
312	22	< 0.1%
Other values (348)	3546	3.5%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
4	6	< 0.1%
5	12	< 0.1%
6	8	< 0.1%
7	5	< 0.1%
8	14	< 0.1%

Value	Count	Frequency (%)
365	96180	96.2%
364	18	< 0.1%
363	16	< 0.1%
362	5	< 0.1%
361	5	< 0.1%

nb_cont
Real number (ℝ_≥0)

Distinct	479
Distinct (%)	0.5%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%

Mean	45.58085396
Minimum	0
Maximum	1847
Zeros	182
Zeros (%)	0.2%
Memory size	781.0 KiB

Quantile statistics

Minimum	0
5-th percentile	8
Q1	21
median	35
Q3	57
95-th percentile	115
Maximum	1847
Range	1847
Interquartile range (IQR)	36

Descriptive statistics

Standard deviation	42.74962571
Coefficient of variation (CV)	0.9378855813
Kurtosis	85.21080245
Mean	45.58085396
Median Absolute Deviation (MAD)	17
Skewness	5.350697573
Sum	4556171
Variance	1827.530498
Monotocity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
17	1848	1.8%
25	1847	1.8%
24	1841	1.8%
22	1831	1.8%
27	1831	1.8%
29	1819	1.8%
21	1804	1.8%
28	1802	1.8%
20	1782	1.8%
30	1772	1.8%
Other values (469)	81781	81.8%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
0	182	0.2%
1	246	0.2%
2	358	0.4%
3	449	0.4%
4	566	0.6%

Value	Count	Frequency (%)
1847	1	< 0.1%
1216	1	< 0.1%
1194	1	< 0.1%
1155	1	< 0.1%
1113	1	< 0.1%

avg_tp_churn
Real number (ℝ_≥0)

Distinct	41
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%

Mean	0.02891477422
Minimum	0.004684040198
Maximum	0.05323896678
Zeros	0
Zeros (%)	0.0%
Memory size	781.0 KiB

Quantile statistics

Minimum	0.004684040198
5-th percentile	0.008277404922
Q1	0.02475870751
median	0.03072007864
Q3	0.03514511531
95-th percentile	0.03903508772
Maximum	0.05323896678
Range	0.04855492658
Interquartile range (IQR)	0.0103864078

Descriptive statistics

Standard deviation	0.009096067923
Coefficient of variation (CV)	0.3145820145
Kurtosis	0.8724151247
Mean	0.02891477422
Median Absolute Deviation (MAD)	0.005507416861
Skewness	-0.5189241464
Sum	2890.263001
Variance	8.273845167 × 10⁵
Monotocity	Not monotonic

Histogram with fixed size bins (bins=41)

Value	Count	Frequency (%)
0.03659559741	12907	12.9%
0.03226293791	12673	12.7%
0.02408960309	9470	9.5%
0.02537772379	7220	7.2%
0.02521266178	5704	5.7%
0.02868947462	4916	4.9%
0.03514511531	4185	4.2%
0.03634149216	3537	3.5%
0.01284422111	3530	3.5%
0.02977013642	3279	3.3%
Other values (31)	32537	32.6%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
0.004684040198	2194	2.2%
0.007636178517	779	0.8%
0.008277404922	2706	2.7%
0.01284422111	3530	3.5%
0.01437371663	455	0.5%

Value	Count	Frequency (%)
0.05323896678	1479	1.5%
0.04661548497	2658	2.7%
0.04658106898	237	0.2%
0.04119318182	188	0.2%
0.03903508772	653	0.7%

churned
Categorical

Distinct	2
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	781.0 KiB

0	97756
1	2202

Length

Max length	1
Median length	1
Mean length	1
Min length	1

Characters and Unicode

Total characters	99958
Distinct characters	2
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	0
2nd row	0
3rd row	0
4th row	0
5th row	0

Value	Count	Frequency (%)
0	97756	97.8%
1	2202	2.2%

Histogram of lengths of the category

Value	Count	Frequency (%)
0	97756	97.8%
1	2202	2.2%

Most occurring characters

Value	Count	Frequency (%)
0	97756	97.8%
1	2202	2.2%

Most occurring categories

Value	Count	Frequency (%)
Decimal Number	99958	100.0%

Most frequent character per category

Value	Count	Frequency (%)
0	97756	97.8%
1	2202	2.2%

Most occurring scripts

Value	Count	Frequency (%)
Common	99958	100.0%

Most frequent character per script

Value	Count	Frequency (%)
0	97756	97.8%
1	2202	2.2%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	99958	100.0%

Most frequent character per block

Value	Count	Frequency (%)
0	97756	97.8%
1	2202	2.2%

Pearson's r

The Pearson's correlation coefficient (r) is a measure of linear correlation between two variables. It's value lies between -1 and +1, -1 indicating total negative linear correlation, 0 indicating no linear correlation and 1 indicating total positive linear correlation. Furthermore, r is invariant under separate changes in location and scale of the two variables, implying that for a linear function the angle to the x-axis does not affect r.

To calculate r for two variables X and Y, one divides the covariance of X and Y by the product of their standard deviations.

Spearman's ρ

The Spearman's rank correlation coefficient (ρ) is a measure of monotonic correlation between two variables, and is therefore better in catching nonlinear monotonic correlations than Pearson's r. It's value lies between -1 and +1, -1 indicating total negative monotonic correlation, 0 indicating no monotonic correlation and 1 indicating total positive monotonic correlation.

To calculate ρ for two variables X and Y, one divides the covariance of the rank variables of X and Y by the product of their standard deviations.

Kendall's τ

Similarly to Spearman's rank correlation coefficient, the Kendall rank correlation coefficient (τ) measures ordinal association between two variables. It's value lies between -1 and +1, -1 indicating total negative correlation, 0 indicating no correlation and 1 indicating total positive correlation.

To calculate τ for two variables X and Y, one determines the number of concordant and discordant pairs of observations. τ is given by the number of concordant pairs minus the discordant pairs divided by the total number of pairs.

Phik (φk)

Phik (φk) is a new and practical correlation coefficient that works consistently between categorical, ordinal and interval variables, captures non-linear dependency and reverts to the Pearson correlation coefficient in case of a bivariate normal input distribution. There is extensive documentation available here.

Cramér's V (φc)

Cramér's V is an association measure for nominal random variables. The coefficient ranges from 0 to 1, with 0 indicating independence and 1 indicating perfect association. The empirical estimators used for Cramér's V have been proved to be biased, even for large samples. We use a bias-corrected measure that has been proposed by Bergsma in 2013 that can be found here.

Count
Matrix

A simple visualization of nullity by column.

Nullity matrix is a data-dense display which lets you quickly visually pick out patterns in data completion.

First rows

	df_index	primary_key	r_age_val	cust_gender_cd	cust_language_cd	cust_mkt_segm_desc	trf_mdl_phonedeal_cd	cust_total_mobile_qty	voice_oob_mean	voice_oob_sum	voice_oob_nat_mean	voice_oob_nat_sum	mean_bill_rev_vs_trf_plan	tenure_days	days_since_moving	nb_cont	avg_tp_churn
0	0	1	0.369409	F	FR	MASS	0	1	0.000000	0.0000	0.000000	0.0000	0.826445	228	365	24	0.036341
1	1	2	0.160948	M	FR	MASS	0	1	16.338333	49.0150	16.338333	49.0150	0.000000	2715	365	19	0.025139
2	2	3	0.495127	F	FR	MASS	0	1	0.000000	0.0000	0.000000	0.0000	0.835336	6211	365	16	0.036596
3	3	4	0.227484	M	FR	MASS	1	2	0.000000	0.0000	0.000000	0.0000	0.827435	152	365	15	0.024090
4	4	5	0.213877	F	NL	MASS	0	1	1.349567	4.0487	1.349567	4.0487	0.986898	3896	365	15	0.035460
5	5	6	0.467429	F	NL	MASS	1	1	0.344367	1.0331	0.000000	0.0000	0.860240	1486	14	53	0.024090
6	6	7	0.511718	M	NL	MASS	0	1	0.000000	0.0000	0.000000	0.0000	1.032640	4762	365	45	0.036341
7	7	8	0.809214	F	FR	MASS	0	1	1.096300	3.2889	1.096300	3.2889	1.177249	614	365	110	0.033741
8	8	9	0.165527	M	NL	MASS	0	1	0.000000	0.0000	0.000000	0.0000	1.377407	3631	365	7	0.029770
9	9	10	0.766809	M	FR	MASS	0	1	0.000000	0.0000	0.000000	0.0000	0.706924	246	365	21	0.053239

Last rows

	df_index	primary_key	r_age_val	cust_gender_cd	cust_language_cd	cust_mkt_segm_desc	trf_mdl_phonedeal_cd	count_orange	cust_total_mobile_qty	voice_oob_mean	voice_oob_sum	voice_oob_nat_mean	voice_oob_nat_sum	mean_bill_rev_vs_trf_plan	tenure_days	days_since_moving	nb_cont	avg_tp_churn
99948	100990	99991	0.843009	F	NL	MASS	0	0	2	0.000000	0.0000	0.000000	0.0000	1.047873	2009	365	60	0.032472
99949	100991	99992	0.441968	M	FR	SOHO	1	0	2	0.000000	0.0000	0.000000	0.0000	1.287842	786	365	34	0.014374
99950	100992	99993	0.117985	Unknown	FR	SOHO	0	0	1	0.195233	0.5857	0.000000	0.0000	1.252494	2543	365	40	0.032263
99951	100993	99994	0.936916	Unknown	FR	MASS	0	0	1	0.000000	0.0000	0.000000	0.0000	0.859313	3839	126	47	0.036341
99952	100994	99995	0.532780	F	FR	MASS	1	0	3	0.000000	0.0000	0.000000	0.0000	0.901392	4455	365	21	0.024090
99953	100995	99996	0.581166	F	FR	MASS	1	0	2	0.000000	0.0000	0.000000	0.0000	0.835612	128	365	89	0.035145
99954	100996	99997	0.900034	M	FR	MASS	0	0	2	5.809700	17.4291	5.809700	17.4291	0.999819	7147	365	36	0.038040
99955	100997	99998	0.741915	F	FR	MASS	0	0	2	0.000000	0.0000	0.000000	0.0000	0.835333	1472	365	13	0.029770
99956	100998	99999	0.067159	F	NL	MASS	0	1	1	0.000000	0.0000	0.000000	0.0000	0.900404	6045	365	51	0.032472
99957	100999	100000	0.786798	M	FR	MASS	0	0	1	1.178967	3.5369	1.123867	3.3716	0.908269	1519	365	52	0.046615

Overview

Variables

Most occurring characters

Most occurring categories

Most frequent character per category

Most occurring scripts

Most frequent character per script

Most occurring blocks

Most frequent character per block

Most occurring characters

Most occurring categories

Most frequent character per category

Most occurring scripts

Most frequent character per script

Most occurring blocks

Most frequent character per block

Most occurring characters

Most occurring categories

Most frequent character per category

Most occurring scripts

Most frequent character per script

Most occurring blocks

Most frequent character per block

Most occurring characters

Most occurring categories

Most frequent character per category

Most occurring scripts

Most frequent character per script

Most occurring blocks

Most frequent character per block

Most occurring characters

Most occurring categories

Most frequent character per category

Most occurring scripts

Most frequent character per script

Most occurring blocks

Most frequent character per block

Most occurring characters

Most occurring categories

Most frequent character per category

Most occurring scripts

Most frequent character per script

Most occurring blocks

Most frequent character per block

Interactions

Correlations

Pearson's r

Spearman's ρ

Kendall's τ

Phik (φk)

Cramér's V (φc)

Missing values

Sample

First rows

Last rows